# -*- coding: utf-8 -*-

# Scrapy settings for douguo2 project
#
# For simplicity, this file contains only settings considered important or
# commonly used. You can find more settings consulting the documentation:
#
#     https://doc.scrapy.org/en/latest/topics/settings.html
#     https://doc.scrapy.org/en/latest/topics/downloader-middleware.html
#     https://doc.scrapy.org/en/latest/topics/spider-middleware.html

BOT_NAME = 'douguo2'

SPIDER_MODULES = ['douguo2.spiders']
NEWSPIDER_MODULE = 'douguo2.spiders'

FEED_EXPORT_ENCODING = 'utf-8'
# Crawl responsibly by identifying yourself (and your website) on the user-agent
#USER_AGENT = 'douguo2 (+http://www.yourdomain.com)'

# Obey robots.txt rules
ROBOTSTXT_OBEY = False

# Configure maximum concurrent requests performed by Scrapy (default: 16)
#CONCURRENT_REQUESTS = 32

# Configure a delay for requests for the same website (default: 0)
# See https://doc.scrapy.org/en/latest/topics/settings.html#download-delay
# See also autothrottle settings and docs
# DOWNLOAD_DELAY = 3
# RANDOMIZE_DOWNLOAD_DELAY = True
# The download delay setting will honor only one of:
#CONCURRENT_REQUESTS_PER_DOMAIN = 16
#CONCURRENT_REQUESTS_PER_IP = 16

# Disable cookies (enabled by default)
COOKIES_ENABLED = False

# Disable Telnet Console (enabled by default)
#TELNETCONSOLE_ENABLED = False

# Override the default request headers:
#DEFAULT_REQUEST_HEADERS = {
#   'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
#   'Accept-Language': 'en',
#}
DEFAULT_REQUEST_HEADERS = {
'accept':'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3',
'accept-encoding':'gzip, deflate, br',
'accept-language':'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7',
'cache-control':'max-age=0',
'referer':'https://www.douguo.com/caipu/fenlei',
'sec-fetch-mode': 'navigate',
'sec-fetch-site': 'none',
'sec-fetch-user': '?1',
'upgrade-insecure-requests':'1',
}

# Enable or disable spider middlewares
# See https://doc.scrapy.org/en/latest/topics/spider-middleware.html
# SPIDER_MIDDLEWARES = {
#    'douguo2.middlewares.Douguo2SpiderMiddleware': 543,
# }

# Enable or disable downloader middlewares
# See https://doc.scrapy.org/en/latest/topics/downloader-middleware.html
DOWNLOADER_MIDDLEWARES = {
    'scrapy.downloadermiddlewares.useragent.UserAgentMiddleware': None,
    'douguo2.middlewares.RandomUserAgent': 401,
    # 'scrapy.downloadermiddlewares.httpproxy.HttpProxyMiddleware':None,
    # 'douguo2.middlewares.RandomProxy': 751,
}

USER_AGENTS = [
    "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; AcooBrowser; .NET CLR 1.1.4322; .NET CLR 2.0.50727)",
    "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Acoo Browser; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)",
    "Mozilla/4.0 (compatible; MSIE 7.0; AOL 9.5; AOLBuild 4337.35; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)",
    "Mozilla/5.0 (Windows; U; MSIE 9.0; Windows NT 9.0; en-US)",
    "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET CLR 2.0.50727; Media Center PC 6.0)",
    "Mozilla/5.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET CLR 1.0.3705; .NET CLR 1.1.4322)",
    "Mozilla/4.0 (compatible; MSIE 7.0b; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.04506.30)",
    "Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN) AppleWebKit/523.15 (KHTML, like Gecko, Safari/419.3) Arora/0.3 (Change: 287 c9dfb30)",
    "Mozilla/5.0 (X11; U; Linux; en-US) AppleWebKit/527+ (KHTML, like Gecko, Safari/419.3) Arora/0.6",
    "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2pre) Gecko/20070215 K-Ninja/2.1.1",
    "Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.9) Gecko/20080705 Firefox/3.0 Kapiko/3.0",
    "Mozilla/5.0 (X11; Linux i686; U;) Gecko/20070322 Kazehakase/0.4.5",
    "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.8) Gecko Fedora/1.9.0.8-1.fc10 Kazehakase/0.5.6",
    "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11",
    "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) AppleWebKit/535.20 (KHTML, like Gecko) Chrome/19.0.1036.7 Safari/535.20",
    "Opera/9.80 (Macintosh; Intel Mac OS X 10.6.8; U; fr) Presto/2.9.168 Version/11.52",
    "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.11 TaoBrowser/2.0 Safari/536.11",
    "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.71 Safari/537.1 LBBROWSER",
    "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; LBBROWSER)",
    "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; QQDownload 732; .NET4.0C; .NET4.0E; LBBROWSER)",
    "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.84 Safari/535.11 LBBROWSER",
    "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E)",
    "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; QQBrowser/7.0.3698.400)",
    "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; QQDownload 732; .NET4.0C; .NET4.0E)",
    "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; SV1; QQDownload 732; .NET4.0C; .NET4.0E; 360SE)",
    "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; QQDownload 732; .NET4.0C; .NET4.0E)",
    "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E)",
    "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1",
    "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1",
    "Mozilla/5.0 (iPad; U; CPU OS 4_2_1 like Mac OS X; zh-cn) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8C148 Safari/6533.18.5",
    "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:2.0b13pre) Gecko/20110307 Firefox/4.0b13pre",
    "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:16.0) Gecko/20100101 Firefox/16.0",
    "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11",
    "Mozilla/5.0 (X11; U; Linux x86_64; zh-CN; rv:1.9.2.10) Gecko/20100922 Ubuntu/10.10 (maverick) Firefox/3.6.10",
    "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/76.0.3809.87 Chrome/76.0.3809.87 Safari/537.36"
]

HTTP_PROXY = [
    'http://117.141.155.243:53281',
    'http://183.196.168.194:9000',
    'http://119.57.109.129:53281',
    'http://119.90.126.106:7777',
    'http://125.46.0.62:53281',
    'http://119.57.105.25:53281',
    'http://1.197.16.222:9999',
    'http://124.205.155.157:9090',
    'http://119.90.126.106:7777',
    'http://117.141.155.243:53281',
    'http://183.196.168.194:9000',
    'http://58.17.125.215:53281',
    'http://124.205.155.146:9090',
    'http://117.141.155.242:53281',
    'http://119.57.108.53:53281',
    'http://124.205.155.156:9090',
    'http://58.247.127.145:53281',
    'http://58.243.50.184:53281',
    'http://175.25.26.117:3128',
    'http://119.57.109.129:53281',
    'http://119.57.108.73:53281',
    'http://119.57.156.90:53281',
    'http://124.67.165.2:3128',
    'http://122.136.212.132:53281',
    'http://221.229.252.98:9797',
    'http://119.57.105.25:53281',
    'http://117.141.155.244:53281',
    'http://124.205.155.150:9090',
    'http://121.69.10.62:9090',
    'http://175.102.3.98:8089',
    'http://101.231.50.154:8000',
    'http://124.205.155.151:9090',
    'http://119.57.108.65:53281',
    'http://124.205.155.153:9090',
    'http://58.17.125.215:53281',
    'http://124.205.155.156:9090',
    'http://58.247.127.145:53281',
    'http://124.205.155.151:9090',
    'http://117.141.155.243:53281',
    'http://119.57.109.129:53281',
    'http://124.205.155.150:9090',
    'http://119.57.108.53:53281',
    'http://119.135.183.115:808',
    'http://121.69.10.62:9090',
    'http://124.205.155.156:9090',
    'http://119.57.108.65:53281',
    'http://175.102.3.98:8089',
    'http://124.205.155.157:9090',
    'http://119.57.108.53:53281',
    'http://220.180.50.14:53281',
    'http://124.205.155.158:9090',
    'http://119.57.108.73:53281',
    'http://124.205.155.157:9090',
    'http://125.46.0.62:53281',
    'http://117.141.155.243:53281',
    'http://183.196.170.247:9000',
    'http://124.205.155.157:9090',
    'http://117.141.155.241:53281',
    'http://124.152.32.140:53281',
    'http://119.57.108.53:53281',
    'http://58.243.50.184:53281',
    'http://124.205.155.152:9090',
    'http://119.57.108.53:53281',
    'http://119.57.108.65:53281',
    'http://119.57.105.25:53281',
    'http://117.141.155.243:53281',
    'http://117.141.155.243:53281',
    'http://117.141.155.244:53281',
    'http://163.125.17.133:8888',
    'http://119.57.156.90:53281',
    'http://119.57.108.53:53281',
    'http://121.69.10.62:9090',
    'http://183.30.204.252:9999',
    'http://119.57.109.129:53281',
    'http://124.205.155.150:9090',
    'http://117.141.155.243:53281',
    'http://183.196.168.194:9000',
    'http://119.57.109.129:53281',
    'http://119.90.126.106:7777',
    'http://125.46.0.62:53281',
    'http://119.57.105.25:53281',
    'http://1.197.16.222:9999',
    'http://124.205.155.157:9090',
    'http://119.90.126.106:7777',
    'http://117.141.155.243:53281',
    'http://183.196.168.194:9000',
    'http://58.17.125.215:53281',
    'http://124.205.155.146:9090',
    'http://117.141.155.242:53281',
    'http://119.57.108.53:53281',
    'http://124.152.32.140:53281',
    'http://124.205.155.158:9090',
    'http://119.57.108.89:53281',
    'http://182.18.13.149:53281',
    'http://183.247.152.98:53281',
    'http://119.57.108.73:53281',
    'http://119.57.156.90:53281',
    'http://124.205.155.156:9090',
    'http://124.205.155.158:9090',
    'http://124.205.155.148:9090',
    'http://124.207.82.166:8008',
    'http://122.136.212.132:53281',
    'http://124.67.165.2:3128',
    'http://119.57.156.90:53281',
    'http://124.205.155.151:9090',
    'http://218.22.7.62:53281',
    'http://101.231.50.154:8000',
    'http://218.66.253.144:8800',
    'http://59.38.60.20:9797',
    'http://125.46.0.62:53281',
    'http://119.57.108.53:53281',
    'http://221.178.176.25:3128',
    'http://119.57.108.53:53281',
    'http://117.141.155.243:53281',
    'http://119.57.108.65:53281',
    'http://117.141.155.241:53281',
    'http://61.145.182.27:53281',
    'http://101.231.50.154:8000',
    'http://61.145.182.27:53281',
    'http://119.90.126.106:7777',
    'http://119.90.126.106:7777',
    'http://218.66.253.145:8800',
    'http://124.207.82.166:8008',
    'http://124.205.155.150:9090',
    'http://183.196.168.194:9000',
    'http://119.57.156.90:53281',
    'http://183.247.152.98:53281',
    'http://101.231.50.154:8000',
    'http://119.57.108.65:53281',
    'http://58.17.125.215:53281',
    'http://61.145.182.27:53281',
    'http://61.145.182.27:53281',
    'http://58.17.125.215:53281',
    'http://112.12.37.196:53281',
    'http://218.22.7.62:53281',
    'http://117.141.155.244:53281',
    'http://124.205.155.156:9090',
    'http://117.141.155.243:53281',
    'http://183.196.168.194:9000',
    'http://124.205.155.152:9090',
    'http://124.205.155.152:9090',
    'http://124.205.155.148:9090',
    'http://124.205.155.146:9090',
    'http://119.57.108.73:53281',
    'http://117.141.155.241:53281',
    'http://124.205.155.152:9090',
    'http://125.46.0.62:53281',
    'http://119.57.108.53:53281',
    'http://124.152.32.140:53281',
    'http://124.205.155.157:9090',
    'http://124.205.155.151:9090',
    'http://123.163.97.3:9999',
    'http://124.152.32.140:53281',
    'http://124.205.155.154:9090',
    'http://119.90.126.106:7777',
    'http://117.141.155.241:53281',
    'http://163.125.158.44:8888',
    'http://119.57.105.25:53281',
    'http://124.205.155.146:9090',
    'http://125.46.0.62:53281',
    'http://119.57.109.129:53281',
    'http://58.249.55.222:9797',
    'http://119.57.105.25:53281',
    'http://220.180.50.14:53281',
    'http://175.25.26.117:3128'
]

# Enable or disable extensions
# See https://doc.scrapy.org/en/latest/topics/extensions.html
#EXTENSIONS = {
#    'scrapy.extensions.telnet.TelnetConsole': None,
#}

# Configure item pipelines
# See https://doc.scrapy.org/en/latest/topics/item-pipeline.html
ITEM_PIPELINES = {
   'douguo2.pipelines.MongoPipeline': 300,
    #'douguo2.pipelines.MysqlPipeline1': 300,
    #'douguo2.pipelines.ImagePipeline': 301,
}

# Enable and configure the AutoThrottle extension (disabled by default)
# See https://doc.scrapy.org/en/latest/topics/autothrottle.html
#AUTOTHROTTLE_ENABLED = True
# The initial download delay
#AUTOTHROTTLE_START_DELAY = 5
# The maximum download delay to be set in case of high latencies
#AUTOTHROTTLE_MAX_DELAY = 60
# The average number of requests Scrapy should be sending in parallel to
# each remote server
#AUTOTHROTTLE_TARGET_CONCURRENCY = 1.0
# Enable showing throttling stats for every response received:
#AUTOTHROTTLE_DEBUG = False

# Enable and configure HTTP caching (disabled by default)
# See https://doc.scrapy.org/en/latest/topics/downloader-middleware.html#httpcache-middleware-settings
#HTTPCACHE_ENABLED = True
#HTTPCACHE_EXPIRATION_SECS = 0
#HTTPCACHE_DIR = 'httpcache'
#HTTPCACHE_IGNORE_HTTP_CODES = []
#HTTPCACHE_STORAGE = 'scrapy.extensions.httpcache.FilesystemCacheStorage'

# 数据库
MONGO_URL = 'localhost'
MONGO_DB = 'tutorial'  # 数据库名

MYSQL_HOST = 'localhost'
MYSQL_DATABASE = 'test1'
MYSQL_PORT = 3306
MYSQL_USER = 'root'
MYSQL_PASSWORD = '123'
# 图片存储
IMAGES_STORE = './images'

# LOG_FILE = "mySpider_mongo.log"
# LOG_LEVEL = "WARNING"

FEED_EXPORT_FIELDS = ['level1', 'level2', 'name', 'author', 'intro', 'materials', 'steps', 'tags', 'url', 'imgs_list']